How to: View a query that a form or report is based on.
Solution:
In the Query view, select the desired query and click 'Open'.
NOTE: A form or report must have a query as its source before proceeding.
1) (Optional) Do the following to determine the source for a form:
a) If the Database window is not activated, activate the Database window.
b) Click the 'Forms' tab in the Database window.
Forms tab
c) Select the desired form from the list box. (The selected form is highlighted.)
d) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
e) Click on the Form Selector.
Single click on form selector.
f) Select the 'View' menu and select 'Properties'.
g) Click the 'Data' tab.
h) Click on the 'Record Source' box.
i) Note and write down the name of the record source.
j) Select the 'Window' menu and select '<database name : Database>'
(where <database name> is the name of the database).
2) (Optional) Do the following to confirm the source for a report.
a) Click the 'Reports' tab in the Database window.
Reports tab
b) Select the desired report from the list box. (The selected report is highlighted.)
c) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
d) Click on the Report Selector.
Report Selector
e) Select the 'View' menu and select 'Properties'.
f) Click the 'Data' tab.
g) Click on the 'Record Source' box. (A down arrow appears.)
h) Note and write down the name for the record source.
i) Select the 'Window' menu and select '<database name : Database>'
(where <database name> is the name of the database).
3) If the Database window is not activated, activate the Database window.
4) Click the 'Queries' tab in the Database window.
Queries tab
5) Select the query in the list box. (The selected query is highlighted.)
NOTE: It is the same name as found in step 1)i) for forms and step 2)h) for reports.
6) Click 'Open'. (The query opens in Datasheet view.)
